package com.example.demo.Mappers;

import com.example.demo.beans.GetZYFYList;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Administrator on 2018-05-25.
 */
@Mapper
public interface GetZYFYListMapper {
    @Select("select OperDateTime,ItemName,ItemType,Specs,Unit,(select Convert(decimal(18,2),Price))   Price,(select Convert(decimal(18,2), Num))   Num,(select Convert(decimal(18,2),  Cost))   Cost,DeptName from Auto_View_ZYDetail where zyh=#{CardNo} or sfzh=#{CardNo} or kh=#{CardNo} and  (OperDateTime>=#{startTime} and OperDateTime<=#{endTime})")
    List<GetZYFYList> getzyfhmx(@Param("CardNo") String CardNo, @Param("startTime")String startTime, @Param("endTime")String endTime);
}
